package com.office.meetingManage.meetroom.dao;

import com.office.meetingManage.meetroom.pojo.OaMeetroom;
import com.office.meetingManage.meetroom.pojo.otherPojo.MeetCountExcel;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/**
 * @Auther: 许月
 * @Date: 2022/10/27/10:50
 */
@Mapper
public interface MeetroomMapper {

    /**
     * 查询会议室
     * @param meetroom
     * @return
     */
    List<OaMeetroom> queryList(@Param("meetroom") OaMeetroom meetroom);

    /**
     * 通过id查询
     * @param mId
     * @return
     */
    OaMeetroom queryBymId(@Param("mId") Integer mId);

    /**
     * 修改会议室
     * @param meetroom
     * @return
     */
    Integer updateMeetRoom(@Param("meetroom") OaMeetroom meetroom);

    /**
     * 删除会议室
     * @param mId
     * @return
     */
    Integer deleteByMid(@Param("mId")Integer mId);

    /**
     * 添加会议室
     * @param meetroom
     * @return
     */
    Integer addMeetRoom(@Param("meetroom") OaMeetroom meetroom);

    /**
     * 会议室使用次数报表导出专用
     * @param startMonth
     * @param nextMonth
     * @return
     */
    List<MeetCountExcel> findMeetCount(@Param("startMonth") String startMonth,@Param("nextMonth") String nextMonth);

    /**
     * 通过会议室全名称查找会议室id
     * @param meetRoomName
     * @return
     */
    List<Integer> findIdByName(@Param("meetRoomName")String meetRoomName);

    /**
     * 通过会议室全地址查找会议室id
     * @param meetRoomPlace
     * @return
     */
    List<Integer> findIdByPlace(@Param("meetRoomPlace") String meetRoomPlace);


}
